"The file [name of file] may have been changed by another user since you last saved it."  Issue affects both network and local files.

When a certain user saves a file in Excel 2010, she gets a message: "The file <name of file> may have been changed by another user since you last saved it."  She can choose to save as another file or overwrite with her changes.  This just started happening a week or so ago.  She was concerned that someone else was accessing her files, but we did several tests that opened, made a change and saved in a matter of seconds, and she still gets the message.  It happens on most files, but not all both network and local.

We already tried the QFE_Saskatchewan registry fix.  I also checked the file server for Services for Macintosh.



  • Edited by T.Townsend Thursday, August 08, 2013 5:47 PM
August 8th, 2013 5:43pm

You may be confused by the error in Excel saying another user. Actually Excel cannot tell who (the real human) is editing the file. Based on my research the No.1 possibility of the error is KB2626998.
2626998  Connection to a network document is lost in the 2007 Office system or in Office 2010 after the computer resumes from standby
http://support.microsoft.com/kb/2626998

For Excel 2010, follow these steps:
a.  Click Start , click Run , type regedit in the Open box, and then click OK .
b.  Locate and then select the following registry subkey: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options
c.  On the Edit menu, point to New , and then click Dword Value .
d.  Type NetworkAvailableTimeInSeconds , and then press Enter.
e.  Right-click NetworkAvailableTimeInSeconds , and then click Modify .
f.  In the Value data box, click Decimal , type a number value, and then click OK .

Note This registry subkey sets the time, in seconds, that Excel waits for the network to resume. For example, if you type 15 for the number value, Excel waits 15 seconds for the network to resume. You might have to do some tests in your own environment to determine an appropriate value. You may have to try multiple numbers.
g.  Locate and then select the following registry subkey.
HKEY_CURRENT_USER\Software\Microsoft\office\14.0\common\Internet
h.  Repeat step 2C through step 2F again. Reuse the same value that you used previously.
i.  Exit Registry Editor.

Feel free to post back. Thanks.

Cheers,
Tony Chen
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please contact tnmff@microsoft.com.

Free Windows Admin Tool Kit Click here and download it now
August 11th, 2013 11:00am

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

Cheers,
Tony Chen
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please contact tnmff@microsoft.com.

August 13th, 2013 8:06am

Hi,
I'm marking the reply as answer as there has been no update for a couple of days.
If you come back to find it doesn't work for you, please reply to us and unmark the answer.

Cheers,
Tony Chen
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please contact tnmff@microsoft.com.

Free Windows Admin Tool Kit Click here and download it now
August 16th, 2013 2:33am

I am sorry to re-open this thread, but we have exactly this problem even with the last update Office 2010 SP2.

we have tried all answers available on the Net, the script we used to test :

{

const HKEY_LOCAL_MACHINE = &H80000002
const HKEY_CURRENT_USER = &H80000001
strComputer = "."
Set StdOut = WScript.StdOut
 
Set oReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\"& strComputer & "\root\default:StdRegProv")

' Attente de 10 secondes de rtablissement du rseau aprs la sortie de veille

strKeyPath = "Software\Microsoft\Office\14.0\Common\internet"
strValueName = "NetworkAvailableTimeInSeconds"
dwValue = 10
oReg.SetDWORDValue HKEY_CURRENT_USER,strKeyPath,strValueName,dwValue

' Attente de 10 secondes de rtablissement du rseau aprs la sortie de veille

strKeyPath = "Software\Microsoft\Office\14.0\Word\Options"
strValueName = "NetworkAvailableTimeInSeconds"
dwValue = 10
oReg.SetDWORDValue HKEY_CURRENT_USER,strKeyPath,strValueName,dwValue

strKeyPath = "Software\Microsoft\Office\14.0\Excel\Options"
strValueName = "NetworkAvailableTimeInSeconds"
dwValue = 10
oReg.SetDWORDValue HKEY_CURRENT_USER,strKeyPath,strValueName,dwValue


' Suppression message Excel suite application MS11-072
' Valeur 2 : Excel will always flush the file cache before the program obtains the time stamp
' Valeur 1 : to have Excel disable the time stamp check and always suppress the dialog box

strKeyPath = "Software\Microsoft\Office\14.0\Excel\Options"
strValueName = "QFE_Saskatchewan"
dwValue = 2
oReg.SetDWORDValue HKEY_CURRENT_USER,strKeyPath,strValueName,dwValue

}

 thanks for your help

 

September 2nd, 2013 1:35pm

it worked.. Now no more messages coming.. 

Thanks

Free Windows Admin Tool Kit Click here and download it now
December 17th, 2014 3:50am

Tony,

Is this the correct thread as we are using newer version of office. Same issue for an excel file saved locally on SP3. The file is being synced to onedrive and using Office 365 subscription for excel.

Would the same fix for office 2010 also work here or would that be a different thread?

Regards,

Bryan

February 3rd, 2015 4:03pm

I too am having this problem on Excel 2013.  It is on a file saved on my PC that is part of my OneDrive files, so I assumed it was a OneDrive sync issue, but it seems not.

Free Windows Admin Tool Kit Click here and download it now
March 26th, 2015 6:38pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics